Pandas Profiling Report

Dataset statistics

Number of variables	25
Number of observations	539040
Missing cells	109561
Missing cells (%)	0.8%
Duplicate rows	591
Duplicate rows (%)	0.1%
Total size in memory	123.1 MiB
Average record size in memory	239.4 B

Variable types

Numeric	13
Categorical	12

Alerts

Dataset has 591 (0.1%) duplicate rows	Duplicates
`month` has a high cardinality: 251 distinct values	High cardinality
`block` has a high cardinality: 2475 distinct values	High cardinality
`street_name` has a high cardinality: 553 distinct values	High cardinality
`resale_price` is highly overall correlated with `floor_area_sqm`	High correlation
`distance_to_mrt_km` is highly overall correlated with `distance_to_mrt_bins`	High correlation
`population_count` is highly overall correlated with `adult_count` and 8 other fields	High correlation
`adult_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`children_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`senior_citizen_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`teenager_count` is highly overall correlated with `population_count` and 9 other fields	High correlation
`young_adult_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`female_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`male_count` is highly overall correlated with `population_count` and 8 other fields	High correlation
`male_female_ratio` is highly overall correlated with `male_female_ratio_bins`	High correlation
`floor_area_sqm` is highly overall correlated with `resale_price` and 2 other fields	High correlation
`lease_commence_date` is highly overall correlated with `floor_area_sqm`	High correlation
`distance_to_mrt_bins` is highly overall correlated with `distance_to_mrt_km` and 1 other fields	High correlation
`codes_name` is highly overall correlated with `distance_to_mrt_bins` and 1 other fields	High correlation
`male_female_ratio_bins` is highly overall correlated with `teenager_count` and 2 other fields	High correlation
`population_bins` is highly overall correlated with `population_count` and 9 other fields	High correlation
`town` is highly overall correlated with `population_count` and 9 other fields	High correlation
`flat_type` is highly overall correlated with `floor_area_sqm` and 1 other fields	High correlation
`flat_model` is highly overall correlated with `flat_type`	High correlation
`mrt_counts` is highly imbalanced (89.9%)	Imbalance
`distance_to_mrt_bins` is highly imbalanced (72.6%)	Imbalance
`male_female_ratio_bins` is highly imbalanced (82.8%)	Imbalance
`resale_price` has 107623 (20.0%) missing values	Missing

Reproduction

Analysis started	2023-03-18 03:49:15.225746
Analysis finished	2023-03-18 03:50:08.898318
Duration	53.67 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

resale_price
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6404
Distinct (%)	1.5%
Missing	107623
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	301820.82

Minimum	29700
Maximum	1123200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	29700
5-th percentile	131400
Q1	205200
median	283950
Q3	373500
95-th percentile	544500
Maximum	1123200
Range	1093500
Interquartile range (IQR)	168300

Descriptive statistics

Standard deviation	129867.22
Coefficient of variation (CV)	0.43027921
Kurtosis	1.4120769
Mean	301820.82
Median Absolute Deviation (MAD)	83250
Skewness	0.99009256
Sum	1.3021063 × 10¹¹
Variance	1.6865496 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
270000	3773	0.7%
315000	3713	0.7%
252000	3606	0.7%
288000	3604	0.7%
360000	3511	0.7%
342000	3476	0.6%
324000	3418	0.6%
297000	3369	0.6%
225000	3312	0.6%
243000	3161	0.6%
Other values (6394)	396474	73.6%
(Missing)	107623	20.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29700	1	< 0.1%
31500	2	< 0.1%
32400	1	< 0.1%
33300	3	< 0.1%
34200	3	< 0.1%
36000	3	< 0.1%
36900	3	< 0.1%
37800	2	< 0.1%
38700	7	< 0.1%
39150	1	< 0.1%

Value	Count	Frequency (%)
1123200	1	< 0.1%
1108800	1	< 0.1%
1087200	2	< 0.1%
1084500	1	< 0.1%
1080000	3	< 0.1%
1068199.2	1	< 0.1%
1062000	1	< 0.1%
1053000	2	< 0.1%
1051200	1	< 0.1%
1044799.2	1	< 0.1%

distance_to_mrt_km
Real number (ℝ)

Distinct	9145
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.65271469

Minimum	0.022112447
Maximum	3.5157764
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	0.022112447
5-th percentile	0.16585551
Q1	0.36758768
median	0.58811823
Q3	0.86051038
95-th percentile	1.3991688
Maximum	3.5157764
Range	3.4936639
Interquartile range (IQR)	0.4929227

Descriptive statistics

Standard deviation	0.38384447
Coefficient of variation (CV)	0.58807389
Kurtosis	1.7324037
Mean	0.65271469
Median Absolute Deviation (MAD)	0.24082632
Skewness	1.0947081
Sum	351839.33
Variance	0.14733658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.8804880701	413	0.1%
0.8806170356	396	0.1%
1.009626078	394	0.1%
0.9620735662	387	0.1%
0.8084054236	385	0.1%
0.9636654817	359	0.1%
1.213218379	356	0.1%
1.170511977	350	0.1%
0.6498798611	297	0.1%
0.4245036351	292	0.1%
Other values (9135)	535411	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02211244716	80	< 0.1%
0.02648832499	39	< 0.1%
0.03602304855	38	< 0.1%
0.03905292277	4	< 0.1%
0.04148001859	10	< 0.1%
0.0434819053	36	< 0.1%
0.04348866364	39	< 0.1%
0.04372690318	92	< 0.1%
0.04389555737	80	< 0.1%
0.04432644791	94	< 0.1%

Value	Count	Frequency (%)
3.515776371	26	< 0.1%
3.491570856	86	< 0.1%
3.454113187	30	< 0.1%
2.150380755	120	< 0.1%
2.123572473	68	< 0.1%
2.101792667	93	< 0.1%
2.095430751	51	< 0.1%
2.089538192	50	< 0.1%
2.080300714	68	< 0.1%
2.080200347	66	< 0.1%

mrt_counts
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

1	531916
2	7124

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	539040
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

Most occurring characters

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	539040	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	539040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	539040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	531916	98.7%
2	7124	1.3%

distance_to_mrt_bins
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

0	491277
1	47621
2	142

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	539040
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	539040	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	539040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	539040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	491277	91.1%
1	47621	8.8%
2	142	< 0.1%

codes_name
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

NS	168124
EW	158306
DT	56264
NE	48480
BP	31571
Other values (9)	76295

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1078080
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EW
2nd row	EW
3rd row	EW
4th row	EW
5th row	EW

Common Values

Value	Count	Frequency (%)
NS	168124	31.2%
EW	158306	29.4%
DT	56264	10.4%
NE	48480	9.0%
BP	31571	5.9%
CC	31076	5.8%
SE	12642	2.3%
SW	12041	2.2%
PE	10370	1.9%
TE	7726	1.4%
Other values (4)	2440	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ns	168124	31.2%
ew	158306	29.4%
dt	56264	10.4%
ne	48480	9.0%
bp	31571	5.9%
cc	31076	5.8%
se	12642	2.3%
sw	12041	2.2%
pe	10370	1.9%
te	7726	1.4%
Other values (4)	2440	0.5%

Most occurring characters

Value	Count	Frequency (%)
E	237524	22.0%
N	216604	20.1%
S	193842	18.0%
W	171448	15.9%
T	65187	6.0%
C	62294	5.8%
D	56264	5.2%
P	43204	4.0%
B	31571	2.9%
G	142	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1078080	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	237524	22.0%
N	216604	20.1%
S	193842	18.0%
W	171448	15.9%
T	65187	6.0%
C	62294	5.8%
D	56264	5.2%
P	43204	4.0%
B	31571	2.9%
G	142	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1078080	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	237524	22.0%
N	216604	20.1%
S	193842	18.0%
W	171448	15.9%
T	65187	6.0%
C	62294	5.8%
D	56264	5.2%
P	43204	4.0%
B	31571	2.9%
G	142	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1078080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	237524	22.0%
N	216604	20.1%
S	193842	18.0%
W	171448	15.9%
T	65187	6.0%
C	62294	5.8%
D	56264	5.2%
P	43204	4.0%
B	31571	2.9%
G	142	< 0.1%

population_count
Real number (ℝ)

Distinct	152
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	42463.732

Minimum	130
Maximum	138490
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	130
5-th percentile	10880
Q1	23940
median	33410
Q3	54880
95-th percentile	95530
Maximum	138490
Range	138360
Interquartile range (IQR)	30940

Descriptive statistics

Standard deviation	30253.571
Coefficient of variation (CV)	0.71245672
Kurtosis	2.3946358
Mean	42463.732
Median Absolute Deviation (MAD)	14910
Skewness	1.5857473
Sum	2.2881157 × 10¹⁰
Variance	9.1527858 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
138490	24506	4.5%
95530	20286	3.8%
85930	15274	2.8%
78150	13356	2.5%
57890	12221	2.3%
68240	10588	2.0%
70930	10064	1.9%
56880	9752	1.8%
59510	9300	1.7%
50130	8995	1.7%
Other values (142)	404498	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
130	46	< 0.1%
810	142	< 0.1%
910	89	< 0.1%
1210	175	< 0.1%
1490	313	0.1%
1520	174	< 0.1%
1580	246	< 0.1%
2080	321	0.1%
2330	99	< 0.1%
2440	215	< 0.1%

Value	Count	Frequency (%)
138490	24506	4.5%
95530	20286	3.8%
85930	15274	2.8%
78150	13356	2.5%
70930	10064	1.9%
68240	10588	2.0%
59830	6958	1.3%
59510	9300	1.7%
57890	12221	2.3%
56880	9752	1.8%

adult_count
Real number (ℝ)

Distinct	151
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	22472.908

Minimum	20
Maximum	72740
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	20
5-th percentile	5920
Q1	12660
median	17440
Q3	29740
95-th percentile	50520
Maximum	72740
Range	72720
Interquartile range (IQR)	17080

Descriptive statistics

Standard deviation	15954.547
Coefficient of variation (CV)	0.70994581
Kurtosis	2.2697044
Mean	22472.908
Median Absolute Deviation (MAD)	7720
Skewness	1.5554882
Sum	1.2109302 × 10¹⁰
Variance	2.5454755 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72740	24506	4.5%
50520	20286	3.8%
45400	15274	2.8%
40960	13356	2.5%
31660	12221	2.3%
37740	10588	2.0%
16570	10283	1.9%
37240	10064	1.9%
30600	9752	1.8%
30090	9300	1.7%
Other values (141)	403210	74.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	46	< 0.1%
440	142	< 0.1%
490	89	< 0.1%
590	175	< 0.1%
800	174	< 0.1%
830	313	0.1%
890	246	< 0.1%
1140	321	0.1%
1180	215	< 0.1%
1250	99	< 0.1%

Value	Count	Frequency (%)
72740	24506	4.5%
50520	20286	3.8%
45400	15274	2.8%
40960	13356	2.5%
37740	10588	2.0%
37240	10064	1.9%
31990	6958	1.3%
31660	12221	2.3%
30600	9752	1.8%
30090	9300	1.7%

children_count
Real number (ℝ)

Distinct	134
Distinct (%)	< 0.1%
Missing	246
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4147.6129

Minimum	50
Maximum	12040
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	50
5-th percentile	930
Q1	2020
median	3150
Q3	6140
95-th percentile	11140
Maximum	12040
Range	11990
Interquartile range (IQR)	4120

Descriptive statistics

Standard deviation	3023.7938
Coefficient of variation (CV)	0.72904436
Kurtosis	0.6933565
Mean	4147.6129
Median Absolute Deviation (MAD)	1630
Skewness	1.2138311
Sum	2.234709 × 10⁹
Variance	9143328.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12040	24506	4.5%
11140	20286	3.8%
4780	15791	2.9%
6960	15274	2.8%
2820	14278	2.6%
7240	13356	2.5%
4830	12221	2.3%
9060	10588	2.0%
6470	10064	1.9%
2330	9798	1.8%
Other values (124)	392632	72.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	142	< 0.1%
60	89	< 0.1%
70	246	< 0.1%
100	321	0.1%
110	175	< 0.1%
120	586	0.1%
200	215	< 0.1%
240	490	0.1%
290	408	0.1%
320	87	< 0.1%

Value	Count	Frequency (%)
12040	24506	4.5%
11140	20286	3.8%
9060	10588	2.0%
7800	7555	1.4%
7240	13356	2.5%
7060	3574	0.7%
6960	15274	2.8%
6890	6958	1.3%
6750	7173	1.3%
6740	6243	1.2%

senior_citizen_count
Real number (ℝ)

Distinct	127
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2595.8679

Minimum	50
Maximum	8130
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	50
5-th percentile	770
Q1	1410
median	2140
Q3	3130
95-th percentile	7830
Maximum	8130
Range	8080
Interquartile range (IQR)	1720

Descriptive statistics

Standard deviation	1817.7502
Coefficient of variation (CV)	0.70024759
Kurtosis	3.1264898
Mean	2595.8679
Median Absolute Deviation (MAD)	820
Skewness	1.8286929
Sum	1.3987574 × 10⁹
Variance	3304215.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8130	24506	4.5%
2980	20286	3.8%
7830	15274	2.8%
880	14311	2.7%
4260	13356	2.5%
2160	12723	2.4%
3850	12221	2.3%
1410	10370	1.9%
2770	10064	1.9%
3550	9752	1.8%
Other values (117)	395977	73.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	115	< 0.1%
70	89	< 0.1%
90	46	< 0.1%
100	316	0.1%
140	175	< 0.1%
190	1059	0.2%
200	87	< 0.1%
240	246	< 0.1%
260	1364	0.3%
310	100	< 0.1%

Value	Count	Frequency (%)
8130	24506	4.5%
7830	15274	2.8%
5320	5072	0.9%
4260	13356	2.5%
4130	4291	0.8%
3980	4014	0.7%
3850	12221	2.3%
3770	3729	0.7%
3700	4085	0.8%
3580	3940	0.7%

teenager_count
Real number (ℝ)

Distinct	137
Distinct (%)	< 0.1%
Missing	246
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5233.5191

Minimum	80
Maximum	16780
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	80
5-th percentile	1030
Q1	2470
median	3950
Q3	6480
95-th percentile	14940
Maximum	16780
Range	16700
Interquartile range (IQR)	4010

Descriptive statistics

Standard deviation	4059.6597
Coefficient of variation (CV)	0.77570361
Kurtosis	1.5546525
Mean	5233.5191
Median Absolute Deviation (MAD)	2030
Skewness	1.4393882
Sum	2.8197887 × 10⁹
Variance	16480837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16780	24506	4.5%
14940	20286	3.8%
9100	15274	2.8%
9730	13356	2.5%
6480	12221	2.3%
8320	10588	2.0%
10130	10064	1.9%
6730	9752	1.8%
8970	9300	1.7%
5360	8995	1.7%
Other values (127)	404452	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80	335	0.1%
90	142	< 0.1%
110	313	0.1%
120	496	0.1%
140	99	< 0.1%
160	174	< 0.1%
240	215	< 0.1%
270	408	0.1%
340	490	0.1%
380	115	< 0.1%

Value	Count	Frequency (%)
16780	24506	4.5%
14940	20286	3.8%
10130	10064	1.9%
9730	13356	2.5%
9100	15274	2.8%
8970	9300	1.7%
8320	10588	2.0%
8210	6958	1.3%
7420	7173	1.3%
6730	9752	1.8%

young_adult_count
Real number (ℝ)

Distinct	134
Distinct (%)	< 0.1%
Missing	246
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6165.5605

Minimum	80
Maximum	22580
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	80
5-th percentile	1240
Q1	3170
median	4610
Q3	8140
95-th percentile	13590
Maximum	22580
Range	22500
Interquartile range (IQR)	4970

Descriptive statistics

Standard deviation	4876.7097
Coefficient of variation (CV)	0.79095967
Kurtosis	3.3882877
Mean	6165.5605
Median Absolute Deviation (MAD)	2110
Skewness	1.7927531
Sum	3.321967 × 10⁹
Variance	23782297
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22580	24506	4.5%
13590	20286	3.8%
11290	15274	2.8%
12630	13356	2.5%
8480	12221	2.3%
5320	11332	2.1%
8810	10588	2.0%
2290	10492	1.9%
11690	10064	1.9%
5220	9855	1.8%
Other values (124)	400820	74.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80	142	< 0.1%
150	823	0.2%
220	321	0.1%
240	99	< 0.1%
270	174	< 0.1%
290	215	< 0.1%
320	408	0.1%
390	100	< 0.1%
440	605	0.1%
460	412	0.1%

Value	Count	Frequency (%)
22580	24506	4.5%
13590	20286	3.8%
12630	13356	2.5%
11690	10064	1.9%
11290	15274	2.8%
10450	9300	1.7%
8810	10588	2.0%
8620	7555	1.4%
8480	12221	2.3%
8440	8995	1.7%

female_count
Real number (ℝ)

Distinct	146
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	21490.697

Minimum	80
Maximum	70600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	80
5-th percentile	5600
Q1	12470
median	16840
Q3	27770
95-th percentile	47670
Maximum	70600
Range	70520
Interquartile range (IQR)	15300

Descriptive statistics

Standard deviation	15300.608
Coefficient of variation (CV)	0.71196428
Kurtosis	2.5725574
Mean	21490.697
Median Absolute Deviation (MAD)	7420
Skewness	1.6242185
Sum	1.1580047 × 10¹⁰
Variance	2.3410862 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70600	24506	4.5%
47670	20286	3.8%
43950	15274	2.8%
39520	13356	2.5%
29080	12221	2.3%
17890	11402	2.1%
33940	10588	2.0%
34890	10064	1.9%
28490	9752	1.8%
29980	9300	1.7%
Other values (136)	402091	74.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
80	46	< 0.1%
390	142	< 0.1%
450	89	< 0.1%
640	175	< 0.1%
760	174	< 0.1%
780	313	0.1%
820	246	< 0.1%
1090	321	0.1%
1200	215	< 0.1%
1220	99	< 0.1%

Value	Count	Frequency (%)
70600	24506	4.5%
47670	20286	3.8%
43950	15274	2.8%
39520	13356	2.5%
34890	10064	1.9%
33940	10588	2.0%
30240	6958	1.3%
29980	9300	1.7%
29080	12221	2.3%
28490	9752	1.8%

male_count
Real number (ℝ)

Distinct	145
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	20973.036

Minimum	50
Maximum	67890
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	50
5-th percentile	5380
Q1	11920
median	16320
Q3	27200
95-th percentile	47860
Maximum	67890
Range	67840
Interquartile range (IQR)	15280

Descriptive statistics

Standard deviation	14961.131
Coefficient of variation (CV)	0.71335078
Kurtosis	2.2136608
Mean	20973.036
Median Absolute Deviation (MAD)	7240
Skewness	1.5460354
Sum	1.1301110 × 10¹⁰
Variance	2.2383545 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
67890	24506	4.5%
47860	20286	3.8%
41980	15274	2.8%
38630	13356	2.5%
17960	12465	2.3%
28810	12221	2.3%
34300	10588	2.0%
36040	10064	1.9%
28390	9752	1.8%
29530	9300	1.7%
Other values (135)	401028	74.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	46	< 0.1%
420	142	< 0.1%
460	89	< 0.1%
570	175	< 0.1%
710	313	0.1%
760	420	0.1%
990	321	0.1%
1110	99	< 0.1%
1240	215	< 0.1%
1410	115	< 0.1%

Value	Count	Frequency (%)
67890	24506	4.5%
47860	20286	3.8%
41980	15274	2.8%
38630	13356	2.5%
36040	10064	1.9%
34300	10588	2.0%
29590	6958	1.3%
29530	9300	1.7%
28810	12221	2.3%
28390	9752	1.8%

male_female_ratio
Real number (ℝ)

Distinct	154
Distinct (%)	< 0.1%
Missing	200
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.9714201

Minimum	0.625
Maximum	1.2362385
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	0.625
5-th percentile	0.89095128
Q1	0.95517634
median	0.97747976
Q3	0.99649
95-th percentile	1.0329607
Maximum	1.2362385
Range	0.61123853
Interquartile range (IQR)	0.04131366

Descriptive statistics

Standard deviation	0.040533059
Coefficient of variation (CV)	0.041725572
Kurtosis	3.0815801
Mean	0.9714201
Median Absolute Deviation (MAD)	0.022153297
Skewness	-0.19392216
Sum	523440.01
Variance	0.0016429289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.9616147309	24506	4.5%
1.003985735	20286	3.8%
0.9551763367	15274	2.8%
0.9774797571	13356	2.5%
0.9907152682	12221	2.3%
1.010606953	10588	2.0%
1.032960734	10064	1.9%
0.9964899965	9752	1.8%
0.9849899933	9300	1.7%
0.9775147929	8995	1.7%
Other values (144)	404498	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.625	46	< 0.1%
0.8447606727	2550	0.5%
0.854368932	2216	0.4%
0.8550295858	213	< 0.1%
0.8668639053	673	0.1%
0.8670212766	100	< 0.1%
0.8756218905	854	0.2%
0.8771121352	1278	0.2%
0.877842755	4085	0.8%
0.88	412	0.1%

Value	Count	Frequency (%)
1.236238532	592	0.1%
1.174603175	318	0.1%
1.115384615	490	0.1%
1.103869654	634	0.1%
1.086092715	408	0.1%
1.076923077	142	< 0.1%
1.051417271	4536	0.8%
1.05046729	5598	1.0%
1.04	1364	0.3%
1.038997214	3041	0.6%

male_female_ratio_bins
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

1	505107
2	33687
3	200
0	46

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	539040
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	539040	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	539040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	539040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	505107	93.7%
2	33687	6.2%
3	200	< 0.1%
0	46	< 0.1%

population_bins
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

0	377740
1	116308
2	44792
3	200

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	539040
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	539040	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	539040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	539040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	377740	70.1%
1	116308	21.6%
2	44792	8.3%
3	200	< 0.1%

month
Categorical

Distinct	251
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

2010-07	3651
2010-06	3499
2001-10	3449
2009-10	3414
2001-07	3337
Other values (246)	521690

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	3773280
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2001-08
2nd row	2002-09
3rd row	2020-10
4th row	2010-10
5th row	2002-08

Common Values

Value	Count	Frequency (%)
2010-07	3651	0.7%
2010-06	3499	0.6%
2001-10	3449	0.6%
2009-10	3414	0.6%
2001-07	3337	0.6%
2002-01	3329	0.6%
2001-11	3289	0.6%
2001-06	3282	0.6%
2010-08	3278	0.6%
2000-11	3264	0.6%
Other values (241)	505248	93.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2010-07	3651	0.7%
2010-06	3499	0.6%
2001-10	3449	0.6%
2009-10	3414	0.6%
2001-07	3337	0.6%
2002-01	3329	0.6%
2001-11	3289	0.6%
2001-06	3282	0.6%
2010-08	3278	0.6%
2000-11	3264	0.6%
Other values (241)	505248	93.7%

Most occurring characters

Value	Count	Frequency (%)
0	1387290	36.8%
2	695849	18.4%
-	539040	14.3%
1	495528	13.1%
9	98918	2.6%
7	95938	2.5%
8	95520	2.5%
6	93540	2.5%
5	91911	2.4%
3	91099	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3234240	85.7%
Dash Punctuation	539040	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1387290	42.9%
2	695849	21.5%
1	495528	15.3%
9	98918	3.1%
7	95938	3.0%
8	95520	3.0%
6	93540	2.9%
5	91911	2.8%
3	91099	2.8%
4	88647	2.7%

Dash Punctuation

Value	Count	Frequency (%)
-	539040	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3773280	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1387290	36.8%
2	695849	18.4%
-	539040	14.3%
1	495528	13.1%
9	98918	2.6%
7	95938	2.5%
8	95520	2.5%
6	93540	2.5%
5	91911	2.4%
3	91099	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3773280	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1387290	36.8%
2	695849	18.4%
-	539040	14.3%
1	495528	13.1%
9	98918	2.6%
7	95938	2.5%
8	95520	2.5%
6	93540	2.5%
5	91911	2.4%
3	91099	2.4%

town
Categorical

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

woodlands	48807
tampines	42733
jurong west	41019
yishun	35734
bedok	34440
Other values (21)	336307

Length

Max length	15
Median length	12
Mean length	9.1008886
Min length	5

Characters and Unicode

Total characters	4905743
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	pasir ris
2nd row	pasir ris
3rd row	pasir ris
4th row	pasir ris
5th row	pasir ris

Common Values

Value	Count	Frequency (%)
woodlands	48807	9.1%
tampines	42733	7.9%
jurong west	41019	7.6%
yishun	35734	6.6%
bedok	34440	6.4%
hougang	29776	5.5%
ang mo kio	27778	5.2%
choa chu kang	24882	4.6%
sengkang	24215	4.5%
bukit batok	24172	4.5%
Other values (16)	205484	38.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bukit	64055	7.9%
jurong	54762	6.8%
woodlands	48807	6.0%
tampines	42733	5.3%
west	41019	5.1%
yishun	35734	4.4%
bedok	34440	4.3%
hougang	29776	3.7%
kio	27778	3.4%
mo	27778	3.4%
Other values (26)	401372	49.7%

Most occurring characters

Value	Count	Frequency (%)
a	515185	10.5%
n	493635	10.1%
o	424314	8.6%
g	327661	6.7%
s	296059	6.0%
e	290393	5.9%
	269214	5.5%
i	240269	4.9%
t	238477	4.9%
u	237682	4.8%
Other values (14)	1572854	32.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4622594	94.2%
Space Separator	269214	5.5%
Other Punctuation	13935	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	515185	11.1%
n	493635	10.7%
o	424314	9.2%
g	327661	7.1%
s	296059	6.4%
e	290393	6.3%
i	240269	5.2%
t	238477	5.2%
u	237682	5.1%
k	213477	4.6%
Other values (12)	1345442	29.1%

Space Separator

Value	Count	Frequency (%)
	269214	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	13935	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4622594	94.2%
Common	283149	5.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	515185	11.1%
n	493635	10.7%
o	424314	9.2%
g	327661	7.1%
s	296059	6.4%
e	290393	6.3%
i	240269	5.2%
t	238477	5.2%
u	237682	5.1%
k	213477	4.6%
Other values (12)	1345442	29.1%

Common

Value	Count	Frequency (%)
	269214	95.1%
/	13935	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4905743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	515185	10.5%
n	493635	10.1%
o	424314	8.6%
g	327661	6.7%
s	296059	6.0%
e	290393	5.9%
	269214	5.5%
i	240269	4.9%
t	238477	4.9%
u	237682	4.8%
Other values (14)	1572854	32.1%

flat_type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

4-room	211801
3-room	156929
5-room	123141
executive	40922
2-room	5664
Other values (2)	583

Length

Max length	16
Median length	6
Mean length	6.2319605
Min length	6

Characters and Unicode

Total characters	3359276
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4-room
2nd row	4-room
3rd row	executive
4th row	4-room
5th row	4-room

Common Values

Value	Count	Frequency (%)
4-room	211801	39.3%
3-room	156929	29.1%
5-room	123141	22.8%
executive	40922	7.6%
2-room	5664	1.1%
1-room	356	0.1%
multi-generation	227	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4-room	211801	39.3%
3-room	156929	29.1%
5-room	123141	22.8%
executive	40922	7.6%
2-room	5664	1.1%
1-room	356	0.1%
multi-generation	227	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	996009	29.6%
-	498118	14.8%
r	498118	14.8%
m	498118	14.8%
4	211801	6.3%
3	156929	4.7%
e	123220	3.7%
5	123141	3.7%
i	41376	1.2%
t	41376	1.2%
Other values (10)	171070	5.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2363267	70.4%
Dash Punctuation	498118	14.8%
Decimal Number	497891	14.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	996009	42.1%
r	498118	21.1%
m	498118	21.1%
e	123220	5.2%
i	41376	1.8%
t	41376	1.8%
u	41149	1.7%
c	40922	1.7%
x	40922	1.7%
v	40922	1.7%
Other values (4)	1135	< 0.1%

Decimal Number

Value	Count	Frequency (%)
4	211801	42.5%
3	156929	31.5%
5	123141	24.7%
2	5664	1.1%
1	356	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	498118	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2363267	70.4%
Common	996009	29.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	996009	42.1%
r	498118	21.1%
m	498118	21.1%
e	123220	5.2%
i	41376	1.8%
t	41376	1.8%
u	41149	1.7%
c	40922	1.7%
x	40922	1.7%
v	40922	1.7%
Other values (4)	1135	< 0.1%

Common

Value	Count	Frequency (%)
-	498118	50.0%
4	211801	21.3%
3	156929	15.8%
5	123141	12.4%
2	5664	0.6%
1	356	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3359276	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	996009	29.6%
-	498118	14.8%
r	498118	14.8%
m	498118	14.8%
4	211801	6.3%
3	156929	4.7%
e	123220	3.7%
5	123141	3.7%
i	41376	1.2%
t	41376	1.2%
Other values (10)	171070	5.1%

block
Categorical

Distinct	2475
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

1	2097
2	2052
101	1776
4	1764
113	1764
Other values (2470)	529587

Length

Max length	4
Median length	3
Mean length	2.9713045
Min length	1

Characters and Unicode

Total characters	1601652
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13 ?
Unique (%)	< 0.1%

Sample

1st row	440
2nd row	473
3rd row	220
4th row	474
5th row	751

Common Values

Value	Count	Frequency (%)
1	2097	0.4%
2	2052	0.4%
101	1776	0.3%
4	1764	0.3%
113	1764	0.3%
110	1751	0.3%
114	1745	0.3%
108	1711	0.3%
107	1706	0.3%
8	1659	0.3%
Other values (2465)	521015	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1	2097	0.4%
2	2052	0.4%
101	1776	0.3%
113	1764	0.3%
4	1764	0.3%
110	1751	0.3%
114	1745	0.3%
108	1711	0.3%
107	1706	0.3%
8	1659	0.3%
Other values (2465)	521015	96.7%

Most occurring characters

Value	Count	Frequency (%)
1	234732	14.7%
2	200947	12.5%
3	169824	10.6%
4	163842	10.2%
6	153148	9.6%
5	150386	9.4%
7	128100	8.0%
0	120763	7.5%
8	111731	7.0%
9	86758	5.4%
Other values (11)	81421	5.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1520231	94.9%
Uppercase Letter	81421	5.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	26660	32.7%
B	22912	28.1%
C	17318	21.3%
D	10195	12.5%
E	1974	2.4%
F	1025	1.3%
G	737	0.9%
H	320	0.4%
J	156	0.2%
M	68	0.1%

Decimal Number

Value	Count	Frequency (%)
1	234732	15.4%
2	200947	13.2%
3	169824	11.2%
4	163842	10.8%
6	153148	10.1%
5	150386	9.9%
7	128100	8.4%
0	120763	7.9%
8	111731	7.3%
9	86758	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	1520231	94.9%
Latin	81421	5.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	26660	32.7%
B	22912	28.1%
C	17318	21.3%
D	10195	12.5%
E	1974	2.4%
F	1025	1.3%
G	737	0.9%
H	320	0.4%
J	156	0.2%
M	68	0.1%

Common

Value	Count	Frequency (%)
1	234732	15.4%
2	200947	13.2%
3	169824	11.2%
4	163842	10.8%
6	153148	10.1%
5	150386	9.9%
7	128100	8.4%
0	120763	7.9%
8	111731	7.3%
9	86758	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1601652	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	234732	14.7%
2	200947	12.5%
3	169824	10.6%
4	163842	10.2%
6	153148	9.6%
5	150386	9.4%
7	128100	8.0%
0	120763	7.5%
8	111731	7.0%
9	86758	5.4%
Other values (11)	81421	5.1%

street_name
Categorical

Distinct	553
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

yishun ring road	9152
ang mo kio avenue 10	7342
bedok reservoir road	7095
ang mo kio avenue 3	6383
hougang avenue 8	5127
Other values (548)	503941

Length

Max length	25
Median length	22
Mean length	17.301354
Min length	9

Characters and Unicode

Total characters	9326122
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	pasir ris drive 4
2nd row	pasir ris drive 6
3rd row	pasir ris street 21
4th row	pasir ris drive 6
5th row	pasir ris street 71

Common Values

Value	Count	Frequency (%)
yishun ring road	9152	1.7%
ang mo kio avenue 10	7342	1.4%
bedok reservoir road	7095	1.3%
ang mo kio avenue 3	6383	1.2%
hougang avenue 8	5127	1.0%
bedok north street 3	4032	0.7%
ang mo kio avenue 4	3970	0.7%
tampines street 21	3904	0.7%
bedok north road	3712	0.7%
woodlands ring road	3652	0.7%
Other values (543)	484671	89.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	163706	9.6%
avenue	126471	7.4%
road	90863	5.3%
drive	47949	2.8%
west	45046	2.6%
woodlands	42888	2.5%
jurong	40593	2.4%
tampines	37862	2.2%
yishun	35734	2.1%
bukit	31096	1.8%
Other values (307)	1051865	61.4%

Most occurring characters

Value	Count	Frequency (%)
	1175033	12.6%
e	1038593	11.1%
a	745442	8.0%
n	651385	7.0%
t	626141	6.7%
r	592318	6.4%
o	579759	6.2%
s	508302	5.5%
i	377976	4.1%
u	318772	3.4%
Other values (27)	2712401	29.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7662523	82.2%
Space Separator	1175033	12.6%
Decimal Number	487601	5.2%
Other Punctuation	965	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1038593	13.6%
a	745442	9.7%
n	651385	8.5%
t	626141	8.2%
r	592318	7.7%
o	579759	7.6%
s	508302	6.6%
i	377976	4.9%
u	318772	4.2%
d	283540	3.7%
Other values (15)	1940295	25.3%

Decimal Number

Value	Count	Frequency (%)
1	134482	27.6%
2	84657	17.4%
4	58659	12.0%
3	58114	11.9%
5	45182	9.3%
6	31842	6.5%
8	25426	5.2%
7	21986	4.5%
0	16466	3.4%
9	10787	2.2%

Space Separator

Value	Count	Frequency (%)
	1175033	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	965	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7662523	82.2%
Common	1663599	17.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1038593	13.6%
a	745442	9.7%
n	651385	8.5%
t	626141	8.2%
r	592318	7.7%
o	579759	7.6%
s	508302	6.6%
i	377976	4.9%
u	318772	4.2%
d	283540	3.7%
Other values (15)	1940295	25.3%

Common

Value	Count	Frequency (%)
	1175033	70.6%
1	134482	8.1%
2	84657	5.1%
4	58659	3.5%
3	58114	3.5%
5	45182	2.7%
6	31842	1.9%
8	25426	1.5%
7	21986	1.3%
0	16466	1.0%
Other values (2)	11752	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9326122	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1175033	12.6%
e	1038593	11.1%
a	745442	8.0%
n	651385	7.0%
t	626141	6.7%
r	592318	6.4%
o	579759	6.2%
s	508302	5.5%
i	377976	4.1%
u	318772	3.4%
Other values (27)	2712401	29.1%

storey_range
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

04 to 06	134068
07 to 09	119555
01 to 03	107840
10 to 12	101653
13 to 15	38554
Other values (20)	37370

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	4312320
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	01 to 03
2nd row	04 to 06
3rd row	10 to 12
4th row	04 to 06
5th row	04 to 06

Common Values

Value	Count	Frequency (%)
04 to 06	134068	24.9%
07 to 09	119555	22.2%
01 to 03	107840	20.0%
10 to 12	101653	18.9%
13 to 15	38554	7.2%
16 to 18	15166	2.8%
19 to 21	6870	1.3%
22 to 24	4380	0.8%
01 to 05	2693	0.5%
06 to 10	2466	0.5%
Other values (15)	5795	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	539040	33.3%
06	136534	8.4%
04	134068	8.3%
07	119555	7.4%
09	119555	7.4%
01	110533	6.8%
03	107840	6.7%
10	104119	6.4%
12	101653	6.3%
15	39806	2.5%
Other values (30)	104417	6.5%

Most occurring characters

Value	Count	Frequency (%)
	1078080	25.0%
0	836424	19.4%
t	539040	12.5%
o	539040	12.5%
1	441891	10.2%
6	152314	3.5%
3	149495	3.5%
4	139108	3.2%
2	127433	3.0%
9	126708	2.9%
Other values (3)	182787	4.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2156160	50.0%
Space Separator	1078080	25.0%
Lowercase Letter	1078080	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	836424	38.8%
1	441891	20.5%
6	152314	7.1%
3	149495	6.9%
4	139108	6.5%
2	127433	5.9%
9	126708	5.9%
7	121862	5.7%
5	44655	2.1%
8	16270	0.8%

Lowercase Letter

Value	Count	Frequency (%)
t	539040	50.0%
o	539040	50.0%

Space Separator

Value	Count	Frequency (%)
	1078080	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3234240	75.0%
Latin	1078080	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	1078080	33.3%
0	836424	25.9%
1	441891	13.7%
6	152314	4.7%
3	149495	4.6%
4	139108	4.3%
2	127433	3.9%
9	126708	3.9%
7	121862	3.8%
5	44655	1.4%

Latin

Value	Count	Frequency (%)
t	539040	50.0%
o	539040	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4312320	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1078080	25.0%
0	836424	19.4%
t	539040	12.5%
o	539040	12.5%
1	441891	10.2%
6	152314	3.5%
3	149495	3.5%
4	139108	3.2%
2	127433	3.0%
9	126708	2.9%
Other values (3)	182787	4.2%

floor_area_sqm
Real number (ℝ)

Distinct	189
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	96.972538

Minimum	31
Maximum	297
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	31
5-th percentile	62
Q1	74
median	99
Q3	114
95-th percentile	144
Maximum	297
Range	266
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	25.189019
Coefficient of variation (CV)	0.25975415
Kurtosis	-0.31237585
Mean	96.972538
Median Absolute Deviation (MAD)	21
Skewness	0.29734772
Sum	52272077
Variance	634.48668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
67	36232	6.7%
104	26226	4.9%
110	21024	3.9%
68	20876	3.9%
84	18640	3.5%
121	17135	3.2%
91	16332	3.0%
92	15953	3.0%
73	15425	2.9%
103	15317	2.8%
Other values (179)	335880	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	356	0.1%
34	69	< 0.1%
35	20	< 0.1%
37	2	< 0.1%
38	19	< 0.1%
39	26	< 0.1%
40	251	< 0.1%
41	68	< 0.1%
42	430	0.1%
43	262	< 0.1%

Value	Count	Frequency (%)
297	1	< 0.1%
280	3	< 0.1%
266	4	< 0.1%
261	3	< 0.1%
259	2	< 0.1%
250	1	< 0.1%
249	3	< 0.1%
243	5	< 0.1%
241	4	< 0.1%
239	2	< 0.1%

flat_model
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.2 MiB

model a	159248
improved	142224
new generation	97840
premium apartment	35553
simplified	30780
Other values (15)	73395

Length

Max length	22
Median length	19
Mean length	9.6175052
Min length	4

Characters and Unicode

Total characters	5184220
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	model a
2nd row	model a
3rd row	apartment
4th row	model a
5th row	model a

Common Values

Value	Count	Frequency (%)
model a	159248	29.5%
improved	142224	26.4%
new generation	97840	18.2%
premium apartment	35553	6.6%
simplified	30780	5.7%
apartment	22295	4.1%
standard	22170	4.1%
maisonette	14859	2.8%
model a2	9131	1.7%
dbss	1725	0.3%
Other values (10)	3215	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
model	169291	20.0%
a	160160	19.0%
improved	142294	16.8%
generation	98067	11.6%
new	97840	11.6%
apartment	57884	6.9%
premium	35671	4.2%
simplified	30780	3.6%
standard	22170	2.6%
maisonette	15923	1.9%
Other values (12)	14497	1.7%

Most occurring characters

Value	Count	Frequency (%)
e	764006	14.7%
m	487761	9.4%
a	445899	8.6%
o	426707	8.2%
n	391007	7.5%
d	390542	7.5%
i	385578	7.4%
r	356902	6.9%
	305537	5.9%
t	269982	5.2%
Other values (14)	960299	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4869118	93.9%
Space Separator	305537	5.9%
Decimal Number	9565	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	764006	15.7%
m	487761	10.0%
a	445899	9.2%
o	426707	8.8%
n	391007	8.0%
d	390542	8.0%
i	385578	7.9%
r	356902	7.3%
t	269982	5.5%
p	267043	5.5%
Other values (11)	683691	14.0%

Decimal Number

Value	Count	Frequency (%)
2	9287	97.1%
1	278	2.9%

Space Separator

Value	Count	Frequency (%)
	305537	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4869118	93.9%
Common	315102	6.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	764006	15.7%
m	487761	10.0%
a	445899	9.2%
o	426707	8.8%
n	391007	8.0%
d	390542	8.0%
i	385578	7.9%
r	356902	7.3%
t	269982	5.5%
p	267043	5.5%
Other values (11)	683691	14.0%

Common

Value	Count	Frequency (%)
	305537	97.0%
2	9287	2.9%
1	278	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5184220	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	764006	14.7%
m	487761	9.4%
a	445899	8.6%
o	426707	8.2%
n	391007	7.5%
d	390542	7.5%
i	385578	7.4%
r	356902	6.9%
	305537	5.9%
t	269982	5.2%
Other values (14)	960299	18.5%

lease_commence_date
Real number (ℝ)

Distinct	54
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1989.4147

Minimum	1966
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.2 MiB

Quantile statistics

Minimum	1966
5-th percentile	1974
Q1	1983
median	1988
Q3	1997
95-th percentile	2005
Maximum	2019
Range	53
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	10.256274
Coefficient of variation (CV)	0.0051554227
Kurtosis	-0.45109548
Mean	1989.4147
Median Absolute Deviation (MAD)	8
Skewness	0.18848978
Sum	1.0723741 × 10⁹
Variance	105.19115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1985	43376	8.0%
1984	31326	5.8%
1997	28346	5.3%
1988	26176	4.9%
1996	23782	4.4%
1998	23268	4.3%
1987	21670	4.0%
1978	20105	3.7%
1986	19205	3.6%
1999	18449	3.4%
Other values (44)	283337	52.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1966	28	< 0.1%
1967	3773	0.7%
1968	1018	0.2%
1969	3944	0.7%
1970	6272	1.2%
1971	4076	0.8%
1972	3113	0.6%
1973	4423	0.8%
1974	6966	1.3%
1975	8954	1.7%

Value	Count	Frequency (%)
2019	3	< 0.1%
2018	2	< 0.1%
2017	56	< 0.1%
2016	1676	0.3%
2015	5227	1.0%
2014	1958	0.4%
2013	3515	0.7%
2012	3350	0.6%
2011	1813	0.3%
2010	1025	0.2%

Auto

Heatmap
Table

	resale_price	distance_to_mrt_km	population_count	adult_count	children_count	senior_citizen_count	teenager_count	young_adult_count	female_count	male_count	male_female_ratio	floor_area_sqm	lease_commence_date	mrt_counts	distance_to_mrt_bins	codes_name	male_female_ratio_bins	population_bins	town	flat_type	storey_range	flat_model
resale_price	1.000	-0.107	0.019	0.018	0.094	-0.102	0.021	-0.008	0.022	0.014	-0.061	0.596	0.438	0.065	0.025	0.093	0.044	0.075	0.147	0.278	0.178	0.254
distance_to_mrt_km	-0.107	1.000	0.054	0.042	-0.031	0.133	0.055	0.069	0.052	0.051	0.049	0.003	-0.177	0.088	0.931	0.423	0.155	0.127	0.366	0.064	0.038	0.105
population_count	0.019	0.054	1.000	0.998	0.944	0.721	0.967	0.970	0.999	0.999	0.253	0.217	0.241	0.111	0.102	0.306	0.249	0.886	0.601	0.101	0.066	0.171
adult_count	0.018	0.042	0.998	1.000	0.945	0.717	0.962	0.966	0.998	0.998	0.253	0.211	0.246	0.115	0.109	0.336	0.204	0.892	0.614	0.103	0.065	0.168
children_count	0.094	-0.031	0.944	0.945	1.000	0.556	0.920	0.893	0.940	0.943	0.283	0.254	0.393	0.131	0.175	0.310	0.254	0.875	0.597	0.135	0.063	0.187
senior_citizen_count	-0.102	0.133	0.721	0.717	0.556	1.000	0.607	0.666	0.736	0.712	-0.182	-0.093	-0.262	0.109	0.104	0.284	0.165	0.578	0.531	0.090	0.049	0.141
teenager_count	0.021	0.055	0.967	0.962	0.920	0.607	1.000	0.973	0.962	0.970	0.352	0.287	0.298	0.126	0.123	0.371	0.557	0.929	0.627	0.141	0.078	0.189
young_adult_count	-0.008	0.069	0.970	0.966	0.893	0.666	0.973	1.000	0.965	0.973	0.330	0.249	0.235	0.150	0.081	0.310	0.359	0.981	0.641	0.129	0.070	0.188
female_count	0.022	0.052	0.999	0.998	0.940	0.736	0.962	0.965	1.000	0.997	0.227	0.212	0.232	0.115	0.102	0.313	0.148	0.890	0.623	0.099	0.067	0.167
male_count	0.014	0.051	0.999	0.998	0.943	0.712	0.970	0.973	0.997	1.000	0.278	0.218	0.244	0.123	0.113	0.318	0.207	0.965	0.635	0.132	0.067	0.200
male_female_ratio	-0.061	0.049	0.253	0.253	0.283	-0.182	0.352	0.330	0.227	0.278	1.000	0.221	0.354	0.075	0.249	0.238	0.774	0.226	0.482	0.102	0.050	0.136
floor_area_sqm	0.596	0.003	0.217	0.211	0.254	-0.093	0.287	0.249	0.212	0.218	0.221	1.000	0.500	0.083	0.063	0.097	0.037	0.081	0.196	0.679	0.055	0.444
lease_commence_date	0.438	-0.177	0.241	0.246	0.393	-0.262	0.298	0.235	0.232	0.244	0.354	0.500	1.000	0.148	0.121	0.245	0.077	0.193	0.453	0.289	0.135	0.408
mrt_counts	0.065	0.088	0.111	0.115	0.131	0.109	0.126	0.150	0.115	0.123	0.075	0.083	0.148	1.000	0.036	0.431	0.030	0.035	0.296	0.075	0.035	0.090
distance_to_mrt_bins	0.025	0.931	0.102	0.109	0.175	0.104	0.123	0.081	0.102	0.113	0.249	0.063	0.121	0.036	1.000	0.722	0.116	0.068	0.336	0.080	0.025	0.090
codes_name	0.093	0.423	0.306	0.336	0.310	0.284	0.371	0.310	0.313	0.318	0.238	0.097	0.245	0.431	0.722	1.000	0.122	0.298	0.619	0.101	0.059	0.139
male_female_ratio_bins	0.044	0.155	0.249	0.204	0.254	0.165	0.557	0.359	0.148	0.207	0.774	0.037	0.077	0.030	0.116	0.122	1.000	0.580	0.293	0.018	0.020	0.071
population_bins	0.075	0.127	0.886	0.892	0.875	0.578	0.929	0.981	0.890	0.965	0.226	0.081	0.193	0.035	0.068	0.298	0.580	1.000	0.554	0.071	0.074	0.141
town	0.147	0.366	0.601	0.614	0.597	0.531	0.627	0.641	0.623	0.635	0.482	0.196	0.453	0.296	0.336	0.619	0.293	0.554	1.000	0.211	0.072	0.235
flat_type	0.278	0.064	0.101	0.103	0.135	0.090	0.141	0.129	0.099	0.132	0.102	0.679	0.289	0.075	0.080	0.101	0.018	0.071	0.211	1.000	0.073	0.665
storey_range	0.178	0.038	0.066	0.065	0.063	0.049	0.078	0.070	0.067	0.067	0.050	0.055	0.135	0.035	0.025	0.059	0.020	0.074	0.072	0.073	1.000	0.113
flat_model	0.254	0.105	0.171	0.168	0.187	0.141	0.189	0.188	0.167	0.200	0.136	0.444	0.408	0.090	0.090	0.139	0.071	0.141	0.235	0.665	0.113	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	resale_price	distance_to_mrt_km	mrt_counts	distance_to_mrt_bins	codes_name	population_count	adult_count	children_count	senior_citizen_count	teenager_count	young_adult_count	female_count	male_count	male_female_ratio	male_female_ratio_bins	population_bins	month	town	flat_type	block	street_name	storey_range	floor_area_sqm	flat_model	lease_commence_date
0	209700.0	1.137651	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2001-08	pasir ris	4-room	440	pasir ris drive 4	01 to 03	118.0	model a	1989
1	204300.0	0.916227	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2002-09	pasir ris	4-room	473	pasir ris drive 6	04 to 06	103.0	model a	1989
2	553500.0	1.344888	1	1	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2020-10	pasir ris	executive	220	pasir ris street 21	10 to 12	152.0	apartment	1993
3	315000.0	0.841172	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2010-10	pasir ris	4-room	474	pasir ris drive 6	04 to 06	105.0	model a	1989
4	219600.0	1.774809	1	1	EW	36350.0	18880.0	3450.0	1550.0	6190.0	5320.0	18380.0	17970.0	0.977693	1	0	2002-08	pasir ris	4-room	751	pasir ris street 71	04 to 06	104.0	model a	1996
5	310500.0	1.150209	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2009-04	pasir ris	5-room	102	pasir ris street 12	04 to 06	122.0	improved	1988
6	333000.0	0.807883	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2019-03	pasir ris	4-room	114	pasir ris street 11	01 to 03	106.0	model a	1989
7	391500.0	0.722514	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2017-02	pasir ris	4-room	416	pasir ris drive 6	07 to 09	105.0	model a	1989
8	264600.0	1.689087	1	1	EW	36350.0	18880.0	3450.0	1550.0	6190.0	5320.0	18380.0	17970.0	0.977693	1	0	2000-05	pasir ris	4-room	746	pasir ris street 71	04 to 06	108.0	model a	1996
9	346500.0	1.150209	1	0	EW	59510.0	30090.0	5050.0	2840.0	8970.0	10450.0	29980.0	29530.0	0.984990	1	1	2015-05	pasir ris	4-room	102	pasir ris street 12	01 to 03	104.0	model a	1988

	resale_price	distance_to_mrt_km	mrt_counts	codes_name	population_count	adult_count	children_count	senior_citizen_count	teenager_count	young_adult_count	female_count	male_count	male_female_ratio	male_female_ratio_bins	month	town	flat_type	block	street_name	storey_range	floor_area_sqm	flat_model	lease_commence_date
539030	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2003-04	bukit panjang	4-room	605	senja road	13 to 15	99.0	model a	1999
539031	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2018-10	bukit panjang	5-room	605	senja road	28 to 30	120.0	improved	1999
539032	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2007-08	bukit panjang	5-room	605	senja road	04 to 06	120.0	improved	1999
539033	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2003-12	bukit panjang	4-room	605	senja road	07 to 09	99.0	model a	1999
539034	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2004-02	bukit panjang	5-room	605	senja road	04 to 06	120.0	improved	1999
539035	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2017-05	bukit panjang	4-room	605	senja road	01 to 03	99.0	model a	1999
539036	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2006-08	bukit panjang	5-room	605	senja road	10 to 12	121.0	improved	1999
539037	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2018-10	bukit panjang	5-room	605	senja road	04 to 06	120.0	improved	1999
539038	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2019-04	bukit panjang	5-room	605	senja road	10 to 12	120.0	improved	1999
539039	NaN	0.198486	1	BP	20240.0	10620.0	2980.0	860.0	2580.0	2530.0	10150.0	10090.0	0.994089	1	2004-07	bukit panjang	5-room	605	senja road	04 to 06	121.0	improved	1999

Most frequently occurring

	resale_price	distance_to_mrt_km	mrt_counts	distance_to_mrt_bins	codes_name	population_count	adult_count	children_count	senior_citizen_count	teenager_count	young_adult_count	female_count	male_count	male_female_ratio	male_female_ratio_bins	month	town	flat_type	block	street_name	storey_range	floor_area_sqm	flat_model	lease_commence_date	# duplicates
0	34200.0	1.213218	1	1	EW	10740.0	5770.0	960.0	1380.0	870.0	1040.0	5360.0	5380.0	1.003731	1	2002-01	bukit merah	1-room	7	telok blangah crescent	04 to 06	31.0	improved	1975	2
1	46800.0	1.213218	1	1	EW	10740.0	5770.0	960.0	1380.0	870.0	1040.0	5360.0	5380.0	1.003731	1	2003-08	bukit merah	1-room	7	telok blangah crescent	04 to 06	31.0	improved	1975	2
2	63000.0	0.365796	1	0	EW	13160.0	6950.0	1120.0	1850.0	1030.0	1350.0	6950.0	6210.0	0.893525	1	2002-10	queenstown	2-room	64	commonwealth drive	01 to 03	46.0	standard	1969	2
3	74700.0	0.880617	1	0	EW	31120.0	16350.0	3750.0	1750.0	3720.0	4270.0	15170.0	15950.0	1.051417	2	2002-07	jurong west	3-room	187	boon lay avenue	10 to 12	59.0	improved	1978	2
4	76500.0	0.438779	1	0	CC	15560.0	7990.0	1150.0	1350.0	1630.0	2510.0	7960.0	7600.0	0.954774	1	2000-08	serangoon	2-room	8	lorong lew lian	10 to 12	44.0	improved	1978	2
5	90000.0	0.113026	1	0	CC	16000.0	8420.0	1370.0	1940.0	1410.0	1730.0	8350.0	7650.0	0.916168	1	2004-11	bukit merah	2-room	45	telok blangah drive	04 to 06	45.0	improved	1976	2
6	90000.0	0.113026	1	0	CC	16000.0	8420.0	1370.0	1940.0	1410.0	1730.0	8350.0	7650.0	0.916168	1	2006-01	bukit merah	2-room	45	telok blangah drive	04 to 06	45.0	improved	1976	2
7	90000.0	1.474655	1	1	TE	14640.0	7620.0	1100.0	1060.0	1770.0	2290.0	7180.0	7460.0	1.038997	2	2003-01	woodlands	3-room	217	marsiling crescent	01 to 03	74.0	model a	1982	2
8	105300.0	1.783739	1	1	NE	39210.0	20100.0	2820.0	3980.0	4170.0	5650.0	20430.0	18780.0	0.919236	1	2001-10	serangoon	3-room	153	serangoon north avenue 1	01 to 03	64.0	simplified	1986	2
9	108000.0	0.201692	1	0	NS	13370.0	6970.0	890.0	2050.0	1110.0	1470.0	7210.0	6160.0	0.854369	1	2003-10	toa payoh	2-room	120	lorong 2 toa payoh	04 to 06	40.0	standard	1968	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values